Analysis

Looking for insights into the Vaccination Uptake by detailed analysis of New Zealand Ministry of Health Covid 19 Vaccination data This Analysis is focused on Northland, NZ

We will explore the rate of change of the unvaccinated by Age, Sex and Ethnicity

This study aims to be impartial and does not warrant the source of the data or the accuracy of the data reports or graphs generated.

The author of this study is vaccinated with the Phizer 2021 Covid19 Vaccine and would suggest anyone unsure about getting vaccinated or is looking for further information, that they consult with a registered medical person or seek validated official communications from appropriate authorities.

Plots of current vaccination ratios

from IPython.core.display import display, HTML
from plotly.offline import init_notebook_mode, plot
init_notebook_mode(connected=True)

import modules
import modules.data_prep as dp
import modules.data_viz1 as dv

data = dp.MOH_data()
data.prep_step1_pull_data()
data.prep_step_2_read_all_uptake_data()
data.prep_step_3_generate_report_data()

plot(dv.plot2(data.df_all_weeks_no_gender_age_category), filename = 'figure2.html')
display(HTML('figure2.html'))
Accessing github with Github Personal Access Token: ghp_Z.............DwEJW
Repo at ../data_moh_nz successfully loaded.

The last data commited by the MHO is : '2021-11-03 13:54:22+13:00 e529d98d Nov 2 2021 vaccine data release'

The eligible population is : 161223

Current week is :'21W44'

plot(dv.plot3(data.df_all_weeks_no_gender_age_category), filename = 'figure3.html')
display(HTML('figure3.html'))
df = data.df_all_weeks_no_gender_age_category.query((
    '["European or Other", "Maori"] in `Ethnic group`'
    # ' and `Age Category` == "12-19"'
    # ' and ["12-19","20-39"] in `Age Category`'
    )
).sort_values(["Age Category", "Ethnic group"])


plot(dv.plot_overall_vaccination_status(df),filename = 'figure4.html')
display(HTML('figure4.html'))

The following pltos indicate the amount of first doses received each week. The 2 main large populations are looked at: Maori and European

# import plotly.io as pio
import plotly.express as px
# import plotly.offline as py
ethnic_group="Maori, European or Other"
fig = px.bar(data.df_all_weeks_no_gender.query(f'{ethnic_group.split(", ")} in `Ethnic group`'), 
    x="Week ending", 
    y="First dose administered Changed", 
    title=f"{ethnic_group} -  First dose received",
    facet_col="Ethnic group", 
    # facet_col="Gender",
    color='Age Category',
    text='First dose administered Changed',
    hover_data=[
        "Ethnic group",
        "Age Category",
        "Population unvaccinated at week start",
        "Population unvaccinated at week end",
        "Population",
        "First dose administered_prior",
        "First dose administered Changed",
        "First dose administered Changed as Percent of unvaccinated Population",
    ],)
plot(fig,filename = 'figure5.html')
display(HTML('figure5.html'))
ethnic_group="European or Other"
fig = px.bar(data.df_all_weeks_no_gender.loc[data.df_all_weeks_no_gender['Ethnic group']==ethnic_group], 
    x="Week ending", 
    y="First dose administered Changed", 
    title=f"{ethnic_group} -  First dose received",
    color='Age Category',
    # facet_col="Gender",
    hover_data=[
        "Ethnic group",
        "Age Category",
        "Population unvaccinated at week start",
        "Population unvaccinated at week end",
        "Population",
        "First dose administered_prior",
        "First dose administered Changed",
        "First dose administered Changed as Percent of unvaccinated Population",
    ],)
plot(fig,filename = 'figure6.html')
display(HTML('figure6.html'))
ethnic_group="Maori"
fig = px.bar(data.df_all_weeks_no_gender.loc[data.df_all_weeks_no_gender['Ethnic group']==ethnic_group], 
    x="Week ending", 
    y="First dose administered Changed", 
    title=f"{ethnic_group} -  First dose received",
    color='Age Category',
    # facet_col="Gender",
    hover_data=[
        "Ethnic group",
        "Age Category",
        "Population unvaccinated at week start",
        "Population unvaccinated at week end",
        "Population",
        "First dose administered_prior",
        "First dose administered Changed",
        "First dose administered Changed as Percent of unvaccinated Population",
    ],)
plot(fig,filename = 'figure7.html')
display(HTML('figure7.html'))

References

Data source: Ministry of Health, New Zealand COVID-19 Data - https://github.com/minhealthnz/nz-covid-data

Further information

Northland DHB, COVID-19 Northland Hub: https://www.northlanddhb.org.nz/home/covid-19/covid-19-northland-hub/